100 |
How can I programmatically change the column where incremental searching is performed
With Exgantt1 .Columns.Add("Column 1") .Columns.Add("Column 2") With .Items .set_CellCaption(.AddItem("Item 1"),1,"SubItem 1") End With .SearchColumnIndex = 1 End With |
99 |
How do I disable the full-row selection in the control
With Exgantt1 .FullRowSelect = False .Columns.Add("Column") .Items.AddItem("One") .Items.AddItem("Two") End With |
98 |
Is there any option to specify the height of the items, before adding them
With Exgantt1 .DefaultItemHeight = 32 .Columns.Add("Column") .Items.AddItem("One") .Items.AddItem("Two") End With |
97 |
How do lock / fix some columns to the control, so I can see them all the time, event if I scroll the columns
With Exgantt1 .CountLockedColumns = 1 .BackColorLock = Color.FromArgb(240,240,240) .ColumnAutoResize = False .Columns.Add("Locked").Width = 128 .Columns.Add("Un-Locked 1").Width = 128 .Columns.Add("Un-Locked 2").Width = 128 .Columns.Add("Un-Locked 3").Width = 128 With .Items .set_CellCaption(.AddItem("locked"),1,"unlocked") End With End With |
96 |
How do I change the control's background / foreground color on the locked area
With Exgantt1 .CountLockedColumns = 1 .ForeColorLock = Color.FromArgb(240,240,240) .BackColorLock = Color.FromArgb(128,128,128) .ColumnAutoResize = False .Columns.Add("Locked").Width = 128 .Columns.Add("Un-Locked 1").Width = 128 .Columns.Add("Un-Locked 2").Width = 128 .Columns.Add("Un-Locked 3").Width = 128 With .Items .set_CellCaption(.AddItem("locked"),1,"unlocked") End With End With |
95 |
How do I change the control's foreground color
With Exgantt1 .ForeColor = Color.FromArgb(120,120,120) .Columns.Add("Column") .Items.AddItem("item") End With |
94 |
How do I change the control's background color
|
93 |
How do I use my own icons for my radio buttons
With Exgantt1 .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") .set_RadioImage(False,1) .set_RadioImage(True,2) .Columns.Add("Radio").set_Def(exontrol.EXGANTTLib.DefColumnEnum.exCellHasRadioButton,True) With .Items .AddItem("Radio 1") .set_CellState(.AddItem("Radio 2"),0,1) .AddItem("Radio 3") End With End With |
92 |
How do I use my own icons for checkbox cells
With Exgantt1 .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") .set_CheckImage(exontrol.EXGANTTLib.CheckStateEnum.Unchecked,1) .set_CheckImage(exontrol.EXGANTTLib.CheckStateEnum.Checked,2) .Columns.Add("Check").set_Def(exontrol.EXGANTTLib.DefColumnEnum.exCellHasCheckBox,True) With .Items .AddItem("Check 1") .set_CellState(.AddItem("Check 2"),0,1) End With End With |
91 |
How do I perform my own sorting when user clicks the column's header
With Exgantt1 .SortOnClick = exontrol.EXGANTTLib.SortOnClickEnum.exUserSort .Columns.Add("Column") .Items.AddItem("Item 1") .Items.AddItem("Item 2") End With |
90 |
How do I disable sorting a specified column when clicking its header
With Exgantt1 .Columns.Add("1") .Columns.Add("NoSort").AllowSort = False End With |
89 |
How do I disable sorting the columns when clicking the control's header
|
88 |
How do I put a picture on the center of the control
With Exgantt1 .Picture = Exgantt1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)") .PictureDisplay = exontrol.EXGANTTLib.PictureDisplayEnum.MiddleCenter End With |
87 |
How do I resize/stretch a picture on the control's background
With Exgantt1 .Picture = Exgantt1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)") .PictureDisplay = exontrol.EXGANTTLib.PictureDisplayEnum.Stretch End With |
86 |
How do I put a picture on the control's center right bottom side
With Exgantt1 .Picture = Exgantt1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)") .PictureDisplay = exontrol.EXGANTTLib.PictureDisplayEnum.LowerRight End With |
85 |
How do I put a picture on the control's center left bottom side
With Exgantt1 .Picture = Exgantt1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)") .PictureDisplay = exontrol.EXGANTTLib.PictureDisplayEnum.LowerLeft End With |
84 |
How do I put a picture on the control's center top side
With Exgantt1 .Picture = Exgantt1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)") .PictureDisplay = exontrol.EXGANTTLib.PictureDisplayEnum.UpperCenter End With |
83 |
How do I put a picture on the control's right top corner
With Exgantt1 .Picture = Exgantt1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)") .PictureDisplay = exontrol.EXGANTTLib.PictureDisplayEnum.UpperRight End With |
82 |
How do I put a picture on the control's left top corner
With Exgantt1 .Picture = Exgantt1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)") .PictureDisplay = exontrol.EXGANTTLib.PictureDisplayEnum.UpperLeft End With |
81 |
How do I put a picture on the control's background
|
80 |
How do I sort descending a column, and put the sorting icon in the column's header
With Exgantt1 .Columns.Add("Column") With .Items .AddItem("Item 1") .AddItem("Item 2") .AddItem("Item 3") End With .Columns.Item(0).SortOrder = exontrol.EXGANTTLib.SortOrderEnum.SortDescending End With |
79 |
How do I sort ascending a column, and put the sorting icon in the column's header
With Exgantt1 .Columns.Add("Column") With .Items .AddItem("Item 3") .AddItem("Item 1") .AddItem("Item 2") End With .Columns.Item(0).SortOrder = exontrol.EXGANTTLib.SortOrderEnum.SortAscending End With |
78 |
How do I perform my own/custom sort, using my extra strings
With Exgantt1 .Columns.Add("desc").SortType = exontrol.EXGANTTLib.SortTypeEnum.SortUserData With .Items .set_CellData(.AddItem("A"),0,"C") .set_CellData(.AddItem("B"),0,"B") .set_CellData(.AddItem("C"),0,"A") .SortChildren(0,0,False) End With End With |
77 |
How do I perform my own/custom sort, using my extra numbers
With Exgantt1 .Columns.Add("desc").SortType = exontrol.EXGANTTLib.SortTypeEnum.SortUserData With .Items .set_CellData(.AddItem(0),0,2) .set_CellData(.AddItem(1),0,1) .set_CellData(.AddItem(2),0,0) .SortChildren(0,0,False) End With End With |
76 |
By default, the column gets sorted as strings, so how do I sort a column by time only
With Exgantt1 .Columns.Add("desc").SortType = exontrol.EXGANTTLib.SortTypeEnum.SortTime With .Items .AddItem("11:00") .AddItem("10:10") .AddItem("12:12") .SortChildren(0,0,False) End With End With |
75 |
By default, the column gets sorted as strings, so how do I sort a column by date and time
With Exgantt1 .Columns.Add("desc").SortType = exontrol.EXGANTTLib.SortTypeEnum.SortDateTime With .Items .AddItem(#1/1/2001 11:00:00 AM#) .AddItem(#1/1/2001 10:10:00 AM#) .AddItem(#1/3/2003#) .SortChildren(0,0,False) End With End With |
74 |
By default, the column gets sorted as strings, so how do I sort a column by dates
With Exgantt1 .Columns.Add("desc").SortType = exontrol.EXGANTTLib.SortTypeEnum.SortDate With .Items .AddItem(#1/1/2001#) .AddItem(#1/2/2002#) .AddItem(#1/3/2003#) .SortChildren(0,0,False) End With End With |
73 |
How do I sort a column by numbers
With Exgantt1 .Columns.Add("desc").SortType = exontrol.EXGANTTLib.SortTypeEnum.SortNumeric With .Items .AddItem(1) .AddItem(5) .AddItem(10) .SortChildren(0,0,False) End With End With |
72 |
How do I hide the control's header bar
With Exgantt1 .HeaderVisible = False End With |
71 |
How do change the visual appearance for the control's header bar, using EBN
|
70 |
How do I remove the control's border
|
69 |
I have a hierarchy and I need to filter only root items that match, with thier childs
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exLinesAtRoot .FilterInclude = exontrol.EXGANTTLib.FilterIncludeEnum.exRootsWithChilds With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exFilter .Filter = "R1" End With With .Items h = .AddItem("R1") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") .set_ExpandItem(h,True) h = .AddItem("R2") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") End With .ApplyFilter() End With |
68 |
I have a hierarchy and I need to filter only root items that match, without thier childs
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exLinesAtRoot .FilterInclude = exontrol.EXGANTTLib.FilterIncludeEnum.exRootsWithoutChilds With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exFilter .Filter = "R1" End With With .Items h = .AddItem("R1") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") .set_ExpandItem(h,True) h = .AddItem("R2") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") End With .ApplyFilter() End With |
67 |
I have a hierarchy and I need to filter only parent items that match, including thier childs
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exLinesAtRoot .FilterInclude = exontrol.EXGANTTLib.FilterIncludeEnum.exItemsWithChilds With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exFilter .Filter = "R1" End With With .Items h = .AddItem("R1") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") .set_ExpandItem(h,True) h = .AddItem("R2") .InsertItem(h,Nothing,"C1") .InsertItem(h,Nothing,"C2") End With .ApplyFilter() End With |
66 |
How can I get ride/hide of the "Filter For" field
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .DisplayFilterPattern = False End With End With |
65 |
Is there any way to get listed only visible items in the drop down filter window
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exLinesAtRoot .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarAll,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarBlanks,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarNonBlanks,"") With .Columns.Add("P1") .DisplayFilterButton = True .DisplayFilterPattern = False .FilterList = exontrol.EXGANTTLib.FilterListEnum.exVisibleItems End With With .Columns.Add("P2") .DisplayFilterButton = True .DisplayFilterPattern = False End With With .Items h = .AddItem("R1") .set_CellCaption(h,1,"R2") .set_CellCaption(.InsertItem(h,Nothing,"Cell 1.1"),1,"Cell 1.2") .set_CellCaption(.InsertItem(h,Nothing,"Cell 2.1"),1,"Cell 2.2") End With End With |
64 |
How do I filter for items that match exactly the specified string
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exFilter .Filter = "Item 1" End With .Items.AddItem("Item 1") .Items.AddItem("Item 2") .Items.AddItem("Item 3") .ApplyFilter() End With |
63 |
How can I can I programmatically filter for items with a specified icon assigned
With Exgantt1 .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exImage .Filter = 1 End With With .Items .set_CellImage(.AddItem("Image 1"),0,1) .set_CellImage(.AddItem("Image 1"),0,1) .set_CellImage(.AddItem("Image 2"),0,2) .set_CellImage(.AddItem("Image 3"),0,3) End With .ApplyFilter() End With |
62 |
How can I can I programmatically filter the checked items
With Exgantt1 With .Columns.Add("Column") .set_Def(exontrol.EXGANTTLib.DefColumnEnum.exCellHasCheckBox,True) .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exCheck .Filter = 0 End With .Items.AddItem(0) With .Items .set_CellState(.AddItem(1),0,1) End With .Items.AddItem(2) .ApplyFilter() End With |
61 |
How can I can I filter programmatically the items based on some numerichal rules
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exNumeric .Filter = "> 0 <= 1" End With .Items.AddItem(0) .Items.AddItem(1) .Items.AddItem(2) .ApplyFilter() End With |
60 |
How can I can I filter programmatically the items based on a range/interval of dates
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .DisplayFilterDate = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exDate .Filter = "1/1/2001 to 1/1/2002" End With .Items.AddItem(#1/1/2001#) .Items.AddItem(#2/1/2002#) .ApplyFilter() End With |
59 |
How can I can I filter programmatically given a specified pattern using wild characters like * or
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exPattern .Filter = "0*" End With .Items.AddItem(0) .Items.AddItem("00") .Items.AddItem(1) .Items.AddItem("11") .ApplyFilter() End With |
58 |
How can I can I select programmatically "Blanks/NonBlanks" option in the column's drop down filter
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exBlanks End With .ApplyFilter() End With |
57 |
How can I display the column's filter
With Exgantt1 .Columns.Add("").DisplayFilterButton = True End With |
56 |
How can I show only the vertical scroll bar
With Exgantt1 .ColumnAutoResize = True .ScrollBars = exontrol.EXGANTTLib.ScrollBarsEnum.exDisableNoVertical .Columns.Add(1) .Columns.Add(2) End With |
55 |
How can I show the control's grid lines only for added/visible items
With Exgantt1 .MarkSearchColumn = False .DrawGridLines = exontrol.EXGANTTLib.GridLinesEnum.exRowLines .Columns.Add("Column 1") .Columns.Add("Column 2") .Items.AddItem(0) .Items.AddItem(1) .Items.AddItem(2) End With |
54 |
Can I hide the hierarchy lines
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exGroupLinesAtRoot .HasLines = exontrol.EXGANTTLib.HierarchyLineEnum.exNoLine .Columns.Add("Column") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child") End With End With |
53 |
Can I change the style or type for the hierarchy lines
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exGroupLinesAtRoot .HasLines = exontrol.EXGANTTLib.HierarchyLineEnum.exThinLine .Columns.Add("Column") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child") End With End With |
52 |
Can I use my own icons for the +/- ( expand/collapse ) buttons
Dim h With Exgantt1 .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exGroupLinesAtRoot .HasButtons = exontrol.EXGANTTLib.ExpandButtonEnum.exCustom .set_HasButtonsCustom(False,1) .set_HasButtonsCustom(True,2) .Columns.Add("Column") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child") End With End With |
51 |
How do I change visual appearance of the +/- ( expand/collapse ) buttons
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exGroupLinesAtRoot .HasButtons = exontrol.EXGANTTLib.ExpandButtonEnum.exWPlus .Columns.Add("Column") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child") End With End With |
50 |
How can I change the "IsChecked/IsUnchecked" caption in the control's filter bar, when I filter for checked items
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exCheck .Filter = 0 End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarIsChecked,"Check_On") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarIsUnchecked,"Check_Off") .ApplyFilter() End With |
49 |
How can I change the "Checked" caption in the drop down filter window, when I filter for checked items
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exCheck End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarChecked,"with check on") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarUnchecked,"with check off") End With |
48 |
How can I change the name of the week days in the drop down calendar window, being displayed when I filter items between dates
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .DisplayFilterDate = True End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarDateWeekDays,"Du Lu Ma Mi Jo Vi Si") .ApplyFilter() End With |
47 |
How can I change the name of the months in the drop down calendar window, being displayed when I filter items between dates
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .DisplayFilterDate = True End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarDateMonths,"Janvier Février Mars Avril Mai Juin Juillet Août Septembre Octobre Novembre Décembre") .ApplyFilter() End With |
46 |
Can I change the "Today" caption being displayed in the drop down calendar, when I filter for dates
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .DisplayFilterDate = True End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarDateTodayCaption,"Azi") .ApplyFilter() End With |
45 |
The drop down filter window displays a "to" string between two datem when I filter dates. Can I change that
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .DisplayFilterDate = True End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarDateTo,"->") .ApplyFilter() End With |
44 |
How can I filter the items that are between an interval/range of dates
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .DisplayFilterDate = True End With .ApplyFilter() End With |
43 |
Can I change the "Date:" caption when the column's drop down filter window is shown
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .DisplayFilterDate = True End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarDate,"Range") .ApplyFilter() End With |
42 |
Can I filter for values using OR - NOT , instead AND operator
With Exgantt1 With .Columns.Add("Column 1") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exBlanks End With With .Columns.Add("Column 2") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exBlanks End With With .Columns.Add("Column 3") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exBlanks End With .FilterCriteria = "%0 or not %1 and %2" .ApplyFilter() End With |
41 |
Can I change the NOT string in the filter bar
With Exgantt1 With .Columns.Add("Column 1") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exBlanks End With With .Columns.Add("Column 2") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exNonBlanks End With .FilterCriteria = "not %0 or %1" .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarNot," ! ") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarIsNonBlank," ! IsBlank") .ApplyFilter() End With |
40 |
Can I change the OR string in the filter bar
With Exgantt1 With .Columns.Add("Column 1") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exBlanks End With With .Columns.Add("Column 2") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exNonBlanks End With .FilterCriteria = "%0 or %1" .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarOr," | ") .ApplyFilter() End With |
39 |
Can I change the AND string in the filter bar
With Exgantt1 With .Columns.Add("Column 1") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exBlanks End With With .Columns.Add("Column 2") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exNonBlanks End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarAnd," & ") .ApplyFilter() End With |
38 |
The "IsBlank" caption shown in the control's filterbar when I select "Blanks" or "NonBlanks" items in the column's drop down filter window
With Exgantt1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXGANTTLib.FilterTypeEnum.exBlanks End With .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarIsBlank,"Is Empty") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarIsNonBlank,"Is Not Empty") .ApplyFilter() End With |
37 |
Is there any option to remove the tooltip when the cursor hovers the column's drop down filter window
With Exgantt1 .Columns.Add("Column").DisplayFilterButton = True .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarFilterTitle,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarPatternFilterTitle,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarTooltip,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarPatternTooltip,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarFilterForTooltip,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarDateTooltip,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarDateTitle,"") End With |
36 |
How can I change the "Filter For" caption in the column's drop down filter window
With Exgantt1 .Columns.Add("Column").DisplayFilterButton = True .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarFilterForCaption,"new caption") End With |
35 |
Can I remove the "All", "Blanks" and "NonBlanks" items in the drop down filter window
With Exgantt1 .Columns.Add("Column").DisplayFilterButton = True .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarAll,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarBlanks,"") .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarNonBlanks,"") End With |
34 |
How do I change the "All", "Blanks" or/and "NonBlanks" caption in the drop down filter window
With Exgantt1 .Columns.Add("Column").DisplayFilterButton = True .set_Description(exontrol.EXGANTTLib.DescriptionTypeEnum.exFilterBarAll,"new name for (All)") End With |
33 |
How can I change the position of the column
|
32 |
Can I make strikeout the column's header
|
31 |
How can I apply an strikeout font only a portion of the column's header
|
30 |
How can I get underlined only a portion of column's header
|
29 |
How can I underline the column's header
With Exgantt1 .Columns.Add("Column 1").HeaderUnderline = True End With |
28 |
How can I apply an italic font only a portion of the column's header
|
27 |
Is there any option to make italic the column's header
With Exgantt1 .Columns.Add("Column 1").HeaderItalic = True End With |
26 |
How can I bold only a portion of the column's header
|
25 |
Is there any option to bold the column's header
With Exgantt1 .Columns.Add("Column 1").HeaderBold = True End With |
24 |
Why child items are not shown
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exLinesAtRoot .Columns.Add("Column 1") With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) End With End With |
23 |
Does your control support partial-check ( three states ) feature for each column
Dim h With Exgantt1 .LinesAtRoot = exontrol.EXGANTTLib.LinesAtRootEnum.exLinesAtRoot With .Columns.Add("P1") .set_Def(exontrol.EXGANTTLib.DefColumnEnum.exCellHasCheckBox,True) .PartialCheck = True End With With .Columns.Add("P2") .set_Def(exontrol.EXGANTTLib.DefColumnEnum.exCellHasCheckBox,True) .PartialCheck = True End With With .Items h = .AddItem("Root") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) End With End With |
22 |
Is there any option to change the color for the grid lines
|
21 |
Can I change the font to display the column's header
With Exgantt1 .HeaderHeight = 34 .Columns.Add("Column 1").HTMLCaption = "<font Tahoma;14>Column</font> 1" End With |
20 |
Can I change the height of the header bar
|
19 |
Can I display multiple icons to the column's header
|
18 |
How can I draw grid lines only for visible items
With Exgantt1 .MarkSearchColumn = False .DrawGridLines = exontrol.EXGANTTLib.GridLinesEnum.exRowLines .Columns.Add("Column 1") .Columns.Add("Column 2") .Items.AddItem(0) .Items.AddItem(1) .Items.AddItem(2) End With |
17 |
How can I show the control's grid lines
With Exgantt1 .MarkSearchColumn = False .DrawGridLines = exontrol.EXGANTTLib.GridLinesEnum.exAllLines .Columns.Add("Column 1") .Columns.Add("Column 2") .Items.AddItem(0) .Items.AddItem(1) .Items.AddItem(2) End With |
16 |
How can I assign a different background color for the entire column
With Exgantt1 .MarkSearchColumn = False .Columns.Add("Column 1").set_Def(exontrol.EXGANTTLib.DefColumnEnum.exCellBackColor,255) .Columns.Add("Column 2") .Items.AddItem(0) .Items.AddItem(1) .Items.AddItem(2) End With |
15 |
How can I assign a check box for a cell
With Exgantt1 .Columns.Add("Column 1") With .Items .AddItem(0) .set_CellHasCheckBox(.AddItem(1),0,True) .AddItem(2) End With End With |
14 |
How can I assign checkboxes for the entire column
With Exgantt1 .Columns.Add("Column 1").set_Def(exontrol.EXGANTTLib.DefColumnEnum.exCellHasCheckBox,True) .Items.AddItem(0) .Items.AddItem(1) .Items.AddItem(2) End With |
13 |
How can I show both scrollbars
|
12 |
How can I change the column's width
With Exgantt1 .ColumnAutoResize = False .Columns.Add("Column 1").Width = 64 .Columns.Add("Column 2").Width = 128 End With |
11 |
How can I show or hide a column
With Exgantt1 .Columns.Add("Hidden").Visible = False End With |
10 |
How can I hide the searching column
With Exgantt1 .MarkSearchColumn = False .Columns.Add("Column 1") .Columns.Add("Column 2") .Items.AddItem() End With |
9 |
Can I disable sorting a column, when the user clicks the column's header, or drag it to the sort bar
With Exgantt1 .Columns.Add("Unsortable").AllowSort = False .Columns.Add("Sortable") End With |
8 |
Is there any option to align the header to the left and the data to the right
With Exgantt1 .Columns.Add("Left").Alignment = exontrol.EXGANTTLib.AlignmentEnum.LeftAlignment With .Columns.Add("Right") .Alignment = exontrol.EXGANTTLib.AlignmentEnum.RightAlignment .HeaderAlignment = exontrol.EXGANTTLib.AlignmentEnum.RightAlignment End With With .Items .set_CellCaption(.AddItem("left"),1,"right") End With End With |
7 |
Can I display a custom size picture to column's header
|
6 |
How can I insert an icon to column's header
|
5 |
How can I insert an icon to column's header
|
4 |
How can I use HTML format in column's header
|
3 |
How can I change/rename the column's name
|
2 |
How can I add multiple columns
With Exgantt1 With .Columns .Add("Column 1") .Add("Column 2") End With End With |
1 |
How can I add a new column
|